package com.hrd.mybatis.bean.auto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TSpouseExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected int limitStart = -1;

    protected int limitEnd = -1;

    public TSpouseExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimitStart(int limitStart) {
        this.limitStart=limitStart;
    }

    public int getLimitStart() {
        return limitStart;
    }

    public void setLimitEnd(int limitEnd) {
        this.limitEnd=limitEnd;
    }

    public int getLimitEnd() {
        return limitEnd;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andFidIsNull() {
            addCriterion("fID is null");
            return (Criteria) this;
        }

        public Criteria andFidIsNotNull() {
            addCriterion("fID is not null");
            return (Criteria) this;
        }

        public Criteria andFidEqualTo(Integer value) {
            addCriterion("fID =", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotEqualTo(Integer value) {
            addCriterion("fID <>", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidGreaterThan(Integer value) {
            addCriterion("fID >", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fID >=", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidLessThan(Integer value) {
            addCriterion("fID <", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidLessThanOrEqualTo(Integer value) {
            addCriterion("fID <=", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidIn(List<Integer> values) {
            addCriterion("fID in", values, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotIn(List<Integer> values) {
            addCriterion("fID not in", values, "fid");
            return (Criteria) this;
        }

        public Criteria andFidBetween(Integer value1, Integer value2) {
            addCriterion("fID between", value1, value2, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotBetween(Integer value1, Integer value2) {
            addCriterion("fID not between", value1, value2, "fid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIsNull() {
            addCriterion("fItemClassID is null");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIsNotNull() {
            addCriterion("fItemClassID is not null");
            return (Criteria) this;
        }

        public Criteria andFitemclassidEqualTo(Integer value) {
            addCriterion("fItemClassID =", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotEqualTo(Integer value) {
            addCriterion("fItemClassID <>", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidGreaterThan(Integer value) {
            addCriterion("fItemClassID >", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fItemClassID >=", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidLessThan(Integer value) {
            addCriterion("fItemClassID <", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidLessThanOrEqualTo(Integer value) {
            addCriterion("fItemClassID <=", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIn(List<Integer> values) {
            addCriterion("fItemClassID in", values, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotIn(List<Integer> values) {
            addCriterion("fItemClassID not in", values, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidBetween(Integer value1, Integer value2) {
            addCriterion("fItemClassID between", value1, value2, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotBetween(Integer value1, Integer value2) {
            addCriterion("fItemClassID not between", value1, value2, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFinteridIsNull() {
            addCriterion("fInterID is null");
            return (Criteria) this;
        }

        public Criteria andFinteridIsNotNull() {
            addCriterion("fInterID is not null");
            return (Criteria) this;
        }

        public Criteria andFinteridEqualTo(Integer value) {
            addCriterion("fInterID =", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridNotEqualTo(Integer value) {
            addCriterion("fInterID <>", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridGreaterThan(Integer value) {
            addCriterion("fInterID >", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fInterID >=", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridLessThan(Integer value) {
            addCriterion("fInterID <", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridLessThanOrEqualTo(Integer value) {
            addCriterion("fInterID <=", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridIn(List<Integer> values) {
            addCriterion("fInterID in", values, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridNotIn(List<Integer> values) {
            addCriterion("fInterID not in", values, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridBetween(Integer value1, Integer value2) {
            addCriterion("fInterID between", value1, value2, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridNotBetween(Integer value1, Integer value2) {
            addCriterion("fInterID not between", value1, value2, "finterid");
            return (Criteria) this;
        }

        public Criteria andFentryidIsNull() {
            addCriterion("fEntryID is null");
            return (Criteria) this;
        }

        public Criteria andFentryidIsNotNull() {
            addCriterion("fEntryID is not null");
            return (Criteria) this;
        }

        public Criteria andFentryidEqualTo(Integer value) {
            addCriterion("fEntryID =", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidNotEqualTo(Integer value) {
            addCriterion("fEntryID <>", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidGreaterThan(Integer value) {
            addCriterion("fEntryID >", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fEntryID >=", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidLessThan(Integer value) {
            addCriterion("fEntryID <", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidLessThanOrEqualTo(Integer value) {
            addCriterion("fEntryID <=", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidIn(List<Integer> values) {
            addCriterion("fEntryID in", values, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidNotIn(List<Integer> values) {
            addCriterion("fEntryID not in", values, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidBetween(Integer value1, Integer value2) {
            addCriterion("fEntryID between", value1, value2, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidNotBetween(Integer value1, Integer value2) {
            addCriterion("fEntryID not between", value1, value2, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFnoIsNull() {
            addCriterion("fNO is null");
            return (Criteria) this;
        }

        public Criteria andFnoIsNotNull() {
            addCriterion("fNO is not null");
            return (Criteria) this;
        }

        public Criteria andFnoEqualTo(String value) {
            addCriterion("fNO =", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotEqualTo(String value) {
            addCriterion("fNO <>", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoGreaterThan(String value) {
            addCriterion("fNO >", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoGreaterThanOrEqualTo(String value) {
            addCriterion("fNO >=", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLessThan(String value) {
            addCriterion("fNO <", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLessThanOrEqualTo(String value) {
            addCriterion("fNO <=", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLike(String value) {
            addCriterion("fNO like", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotLike(String value) {
            addCriterion("fNO not like", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoIn(List<String> values) {
            addCriterion("fNO in", values, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotIn(List<String> values) {
            addCriterion("fNO not in", values, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoBetween(String value1, String value2) {
            addCriterion("fNO between", value1, value2, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotBetween(String value1, String value2) {
            addCriterion("fNO not between", value1, value2, "fno");
            return (Criteria) this;
        }

        public Criteria andFnameIsNull() {
            addCriterion("fName is null");
            return (Criteria) this;
        }

        public Criteria andFnameIsNotNull() {
            addCriterion("fName is not null");
            return (Criteria) this;
        }

        public Criteria andFnameEqualTo(String value) {
            addCriterion("fName =", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotEqualTo(String value) {
            addCriterion("fName <>", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameGreaterThan(String value) {
            addCriterion("fName >", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameGreaterThanOrEqualTo(String value) {
            addCriterion("fName >=", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameLessThan(String value) {
            addCriterion("fName <", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameLessThanOrEqualTo(String value) {
            addCriterion("fName <=", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameLike(String value) {
            addCriterion("fName like", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotLike(String value) {
            addCriterion("fName not like", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameIn(List<String> values) {
            addCriterion("fName in", values, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotIn(List<String> values) {
            addCriterion("fName not in", values, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameBetween(String value1, String value2) {
            addCriterion("fName between", value1, value2, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotBetween(String value1, String value2) {
            addCriterion("fName not between", value1, value2, "fname");
            return (Criteria) this;
        }

        public Criteria andFsexidIsNull() {
            addCriterion("fSexID is null");
            return (Criteria) this;
        }

        public Criteria andFsexidIsNotNull() {
            addCriterion("fSexID is not null");
            return (Criteria) this;
        }

        public Criteria andFsexidEqualTo(Integer value) {
            addCriterion("fSexID =", value, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidNotEqualTo(Integer value) {
            addCriterion("fSexID <>", value, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidGreaterThan(Integer value) {
            addCriterion("fSexID >", value, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fSexID >=", value, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidLessThan(Integer value) {
            addCriterion("fSexID <", value, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidLessThanOrEqualTo(Integer value) {
            addCriterion("fSexID <=", value, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidIn(List<Integer> values) {
            addCriterion("fSexID in", values, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidNotIn(List<Integer> values) {
            addCriterion("fSexID not in", values, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidBetween(Integer value1, Integer value2) {
            addCriterion("fSexID between", value1, value2, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidNotBetween(Integer value1, Integer value2) {
            addCriterion("fSexID not between", value1, value2, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFbirthdayIsNull() {
            addCriterion("fBirthday is null");
            return (Criteria) this;
        }

        public Criteria andFbirthdayIsNotNull() {
            addCriterion("fBirthday is not null");
            return (Criteria) this;
        }

        public Criteria andFbirthdayEqualTo(Date value) {
            addCriterion("fBirthday =", value, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayNotEqualTo(Date value) {
            addCriterion("fBirthday <>", value, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayGreaterThan(Date value) {
            addCriterion("fBirthday >", value, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayGreaterThanOrEqualTo(Date value) {
            addCriterion("fBirthday >=", value, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayLessThan(Date value) {
            addCriterion("fBirthday <", value, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayLessThanOrEqualTo(Date value) {
            addCriterion("fBirthday <=", value, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayIn(List<Date> values) {
            addCriterion("fBirthday in", values, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayNotIn(List<Date> values) {
            addCriterion("fBirthday not in", values, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayBetween(Date value1, Date value2) {
            addCriterion("fBirthday between", value1, value2, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayNotBetween(Date value1, Date value2) {
            addCriterion("fBirthday not between", value1, value2, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidIsNull() {
            addCriterion("fCardTypeID is null");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidIsNotNull() {
            addCriterion("fCardTypeID is not null");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidEqualTo(Integer value) {
            addCriterion("fCardTypeID =", value, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidNotEqualTo(Integer value) {
            addCriterion("fCardTypeID <>", value, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidGreaterThan(Integer value) {
            addCriterion("fCardTypeID >", value, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCardTypeID >=", value, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidLessThan(Integer value) {
            addCriterion("fCardTypeID <", value, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidLessThanOrEqualTo(Integer value) {
            addCriterion("fCardTypeID <=", value, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidIn(List<Integer> values) {
            addCriterion("fCardTypeID in", values, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidNotIn(List<Integer> values) {
            addCriterion("fCardTypeID not in", values, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidBetween(Integer value1, Integer value2) {
            addCriterion("fCardTypeID between", value1, value2, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidNotBetween(Integer value1, Integer value2) {
            addCriterion("fCardTypeID not between", value1, value2, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardidIsNull() {
            addCriterion("fCardID is null");
            return (Criteria) this;
        }

        public Criteria andFcardidIsNotNull() {
            addCriterion("fCardID is not null");
            return (Criteria) this;
        }

        public Criteria andFcardidEqualTo(String value) {
            addCriterion("fCardID =", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidNotEqualTo(String value) {
            addCriterion("fCardID <>", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidGreaterThan(String value) {
            addCriterion("fCardID >", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidGreaterThanOrEqualTo(String value) {
            addCriterion("fCardID >=", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidLessThan(String value) {
            addCriterion("fCardID <", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidLessThanOrEqualTo(String value) {
            addCriterion("fCardID <=", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidLike(String value) {
            addCriterion("fCardID like", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidNotLike(String value) {
            addCriterion("fCardID not like", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidIn(List<String> values) {
            addCriterion("fCardID in", values, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidNotIn(List<String> values) {
            addCriterion("fCardID not in", values, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidBetween(String value1, String value2) {
            addCriterion("fCardID between", value1, value2, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidNotBetween(String value1, String value2) {
            addCriterion("fCardID not between", value1, value2, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFaddressIsNull() {
            addCriterion("fAddress is null");
            return (Criteria) this;
        }

        public Criteria andFaddressIsNotNull() {
            addCriterion("fAddress is not null");
            return (Criteria) this;
        }

        public Criteria andFaddressEqualTo(String value) {
            addCriterion("fAddress =", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressNotEqualTo(String value) {
            addCriterion("fAddress <>", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressGreaterThan(String value) {
            addCriterion("fAddress >", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressGreaterThanOrEqualTo(String value) {
            addCriterion("fAddress >=", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressLessThan(String value) {
            addCriterion("fAddress <", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressLessThanOrEqualTo(String value) {
            addCriterion("fAddress <=", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressLike(String value) {
            addCriterion("fAddress like", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressNotLike(String value) {
            addCriterion("fAddress not like", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressIn(List<String> values) {
            addCriterion("fAddress in", values, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressNotIn(List<String> values) {
            addCriterion("fAddress not in", values, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressBetween(String value1, String value2) {
            addCriterion("fAddress between", value1, value2, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressNotBetween(String value1, String value2) {
            addCriterion("fAddress not between", value1, value2, "faddress");
            return (Criteria) this;
        }

        public Criteria andFcallingidIsNull() {
            addCriterion("fCallingID is null");
            return (Criteria) this;
        }

        public Criteria andFcallingidIsNotNull() {
            addCriterion("fCallingID is not null");
            return (Criteria) this;
        }

        public Criteria andFcallingidEqualTo(Integer value) {
            addCriterion("fCallingID =", value, "fcallingid");
            return (Criteria) this;
        }

        public Criteria andFcallingidNotEqualTo(Integer value) {
            addCriterion("fCallingID <>", value, "fcallingid");
            return (Criteria) this;
        }

        public Criteria andFcallingidGreaterThan(Integer value) {
            addCriterion("fCallingID >", value, "fcallingid");
            return (Criteria) this;
        }

        public Criteria andFcallingidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCallingID >=", value, "fcallingid");
            return (Criteria) this;
        }

        public Criteria andFcallingidLessThan(Integer value) {
            addCriterion("fCallingID <", value, "fcallingid");
            return (Criteria) this;
        }

        public Criteria andFcallingidLessThanOrEqualTo(Integer value) {
            addCriterion("fCallingID <=", value, "fcallingid");
            return (Criteria) this;
        }

        public Criteria andFcallingidIn(List<Integer> values) {
            addCriterion("fCallingID in", values, "fcallingid");
            return (Criteria) this;
        }

        public Criteria andFcallingidNotIn(List<Integer> values) {
            addCriterion("fCallingID not in", values, "fcallingid");
            return (Criteria) this;
        }

        public Criteria andFcallingidBetween(Integer value1, Integer value2) {
            addCriterion("fCallingID between", value1, value2, "fcallingid");
            return (Criteria) this;
        }

        public Criteria andFcallingidNotBetween(Integer value1, Integer value2) {
            addCriterion("fCallingID not between", value1, value2, "fcallingid");
            return (Criteria) this;
        }

        public Criteria andFworkphoneIsNull() {
            addCriterion("fWorkPhone is null");
            return (Criteria) this;
        }

        public Criteria andFworkphoneIsNotNull() {
            addCriterion("fWorkPhone is not null");
            return (Criteria) this;
        }

        public Criteria andFworkphoneEqualTo(String value) {
            addCriterion("fWorkPhone =", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneNotEqualTo(String value) {
            addCriterion("fWorkPhone <>", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneGreaterThan(String value) {
            addCriterion("fWorkPhone >", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneGreaterThanOrEqualTo(String value) {
            addCriterion("fWorkPhone >=", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneLessThan(String value) {
            addCriterion("fWorkPhone <", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneLessThanOrEqualTo(String value) {
            addCriterion("fWorkPhone <=", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneLike(String value) {
            addCriterion("fWorkPhone like", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneNotLike(String value) {
            addCriterion("fWorkPhone not like", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneIn(List<String> values) {
            addCriterion("fWorkPhone in", values, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneNotIn(List<String> values) {
            addCriterion("fWorkPhone not in", values, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneBetween(String value1, String value2) {
            addCriterion("fWorkPhone between", value1, value2, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneNotBetween(String value1, String value2) {
            addCriterion("fWorkPhone not between", value1, value2, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneIsNull() {
            addCriterion("fHandPhone is null");
            return (Criteria) this;
        }

        public Criteria andFhandphoneIsNotNull() {
            addCriterion("fHandPhone is not null");
            return (Criteria) this;
        }

        public Criteria andFhandphoneEqualTo(String value) {
            addCriterion("fHandPhone =", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneNotEqualTo(String value) {
            addCriterion("fHandPhone <>", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneGreaterThan(String value) {
            addCriterion("fHandPhone >", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneGreaterThanOrEqualTo(String value) {
            addCriterion("fHandPhone >=", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneLessThan(String value) {
            addCriterion("fHandPhone <", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneLessThanOrEqualTo(String value) {
            addCriterion("fHandPhone <=", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneLike(String value) {
            addCriterion("fHandPhone like", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneNotLike(String value) {
            addCriterion("fHandPhone not like", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneIn(List<String> values) {
            addCriterion("fHandPhone in", values, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneNotIn(List<String> values) {
            addCriterion("fHandPhone not in", values, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneBetween(String value1, String value2) {
            addCriterion("fHandPhone between", value1, value2, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneNotBetween(String value1, String value2) {
            addCriterion("fHandPhone not between", value1, value2, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneIsNull() {
            addCriterion("fFamilyPhone is null");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneIsNotNull() {
            addCriterion("fFamilyPhone is not null");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneEqualTo(String value) {
            addCriterion("fFamilyPhone =", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneNotEqualTo(String value) {
            addCriterion("fFamilyPhone <>", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneGreaterThan(String value) {
            addCriterion("fFamilyPhone >", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneGreaterThanOrEqualTo(String value) {
            addCriterion("fFamilyPhone >=", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneLessThan(String value) {
            addCriterion("fFamilyPhone <", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneLessThanOrEqualTo(String value) {
            addCriterion("fFamilyPhone <=", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneLike(String value) {
            addCriterion("fFamilyPhone like", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneNotLike(String value) {
            addCriterion("fFamilyPhone not like", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneIn(List<String> values) {
            addCriterion("fFamilyPhone in", values, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneNotIn(List<String> values) {
            addCriterion("fFamilyPhone not in", values, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneBetween(String value1, String value2) {
            addCriterion("fFamilyPhone between", value1, value2, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneNotBetween(String value1, String value2) {
            addCriterion("fFamilyPhone not between", value1, value2, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFemailIsNull() {
            addCriterion("fEMail is null");
            return (Criteria) this;
        }

        public Criteria andFemailIsNotNull() {
            addCriterion("fEMail is not null");
            return (Criteria) this;
        }

        public Criteria andFemailEqualTo(String value) {
            addCriterion("fEMail =", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailNotEqualTo(String value) {
            addCriterion("fEMail <>", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailGreaterThan(String value) {
            addCriterion("fEMail >", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailGreaterThanOrEqualTo(String value) {
            addCriterion("fEMail >=", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailLessThan(String value) {
            addCriterion("fEMail <", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailLessThanOrEqualTo(String value) {
            addCriterion("fEMail <=", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailLike(String value) {
            addCriterion("fEMail like", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailNotLike(String value) {
            addCriterion("fEMail not like", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailIn(List<String> values) {
            addCriterion("fEMail in", values, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailNotIn(List<String> values) {
            addCriterion("fEMail not in", values, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailBetween(String value1, String value2) {
            addCriterion("fEMail between", value1, value2, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailNotBetween(String value1, String value2) {
            addCriterion("fEMail not between", value1, value2, "femail");
            return (Criteria) this;
        }

        public Criteria andFcallingIsNull() {
            addCriterion("fCalling is null");
            return (Criteria) this;
        }

        public Criteria andFcallingIsNotNull() {
            addCriterion("fCalling is not null");
            return (Criteria) this;
        }

        public Criteria andFcallingEqualTo(String value) {
            addCriterion("fCalling =", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingNotEqualTo(String value) {
            addCriterion("fCalling <>", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingGreaterThan(String value) {
            addCriterion("fCalling >", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingGreaterThanOrEqualTo(String value) {
            addCriterion("fCalling >=", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingLessThan(String value) {
            addCriterion("fCalling <", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingLessThanOrEqualTo(String value) {
            addCriterion("fCalling <=", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingLike(String value) {
            addCriterion("fCalling like", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingNotLike(String value) {
            addCriterion("fCalling not like", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingIn(List<String> values) {
            addCriterion("fCalling in", values, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingNotIn(List<String> values) {
            addCriterion("fCalling not in", values, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingBetween(String value1, String value2) {
            addCriterion("fCalling between", value1, value2, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingNotBetween(String value1, String value2) {
            addCriterion("fCalling not between", value1, value2, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFsrc1idIsNull() {
            addCriterion("fSrc1ID is null");
            return (Criteria) this;
        }

        public Criteria andFsrc1idIsNotNull() {
            addCriterion("fSrc1ID is not null");
            return (Criteria) this;
        }

        public Criteria andFsrc1idEqualTo(Integer value) {
            addCriterion("fSrc1ID =", value, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idNotEqualTo(Integer value) {
            addCriterion("fSrc1ID <>", value, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idGreaterThan(Integer value) {
            addCriterion("fSrc1ID >", value, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fSrc1ID >=", value, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idLessThan(Integer value) {
            addCriterion("fSrc1ID <", value, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idLessThanOrEqualTo(Integer value) {
            addCriterion("fSrc1ID <=", value, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idIn(List<Integer> values) {
            addCriterion("fSrc1ID in", values, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idNotIn(List<Integer> values) {
            addCriterion("fSrc1ID not in", values, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idBetween(Integer value1, Integer value2) {
            addCriterion("fSrc1ID between", value1, value2, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idNotBetween(Integer value1, Integer value2) {
            addCriterion("fSrc1ID not between", value1, value2, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFworkunitIsNull() {
            addCriterion("fWorkUnit is null");
            return (Criteria) this;
        }

        public Criteria andFworkunitIsNotNull() {
            addCriterion("fWorkUnit is not null");
            return (Criteria) this;
        }

        public Criteria andFworkunitEqualTo(String value) {
            addCriterion("fWorkUnit =", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitNotEqualTo(String value) {
            addCriterion("fWorkUnit <>", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitGreaterThan(String value) {
            addCriterion("fWorkUnit >", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitGreaterThanOrEqualTo(String value) {
            addCriterion("fWorkUnit >=", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitLessThan(String value) {
            addCriterion("fWorkUnit <", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitLessThanOrEqualTo(String value) {
            addCriterion("fWorkUnit <=", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitLike(String value) {
            addCriterion("fWorkUnit like", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitNotLike(String value) {
            addCriterion("fWorkUnit not like", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitIn(List<String> values) {
            addCriterion("fWorkUnit in", values, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitNotIn(List<String> values) {
            addCriterion("fWorkUnit not in", values, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitBetween(String value1, String value2) {
            addCriterion("fWorkUnit between", value1, value2, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitNotBetween(String value1, String value2) {
            addCriterion("fWorkUnit not between", value1, value2, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFunitkindidIsNull() {
            addCriterion("fUnitKindID is null");
            return (Criteria) this;
        }

        public Criteria andFunitkindidIsNotNull() {
            addCriterion("fUnitKindID is not null");
            return (Criteria) this;
        }

        public Criteria andFunitkindidEqualTo(Integer value) {
            addCriterion("fUnitKindID =", value, "funitkindid");
            return (Criteria) this;
        }

        public Criteria andFunitkindidNotEqualTo(Integer value) {
            addCriterion("fUnitKindID <>", value, "funitkindid");
            return (Criteria) this;
        }

        public Criteria andFunitkindidGreaterThan(Integer value) {
            addCriterion("fUnitKindID >", value, "funitkindid");
            return (Criteria) this;
        }

        public Criteria andFunitkindidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fUnitKindID >=", value, "funitkindid");
            return (Criteria) this;
        }

        public Criteria andFunitkindidLessThan(Integer value) {
            addCriterion("fUnitKindID <", value, "funitkindid");
            return (Criteria) this;
        }

        public Criteria andFunitkindidLessThanOrEqualTo(Integer value) {
            addCriterion("fUnitKindID <=", value, "funitkindid");
            return (Criteria) this;
        }

        public Criteria andFunitkindidIn(List<Integer> values) {
            addCriterion("fUnitKindID in", values, "funitkindid");
            return (Criteria) this;
        }

        public Criteria andFunitkindidNotIn(List<Integer> values) {
            addCriterion("fUnitKindID not in", values, "funitkindid");
            return (Criteria) this;
        }

        public Criteria andFunitkindidBetween(Integer value1, Integer value2) {
            addCriterion("fUnitKindID between", value1, value2, "funitkindid");
            return (Criteria) this;
        }

        public Criteria andFunitkindidNotBetween(Integer value1, Integer value2) {
            addCriterion("fUnitKindID not between", value1, value2, "funitkindid");
            return (Criteria) this;
        }

        public Criteria andFdutyidIsNull() {
            addCriterion("fDutyID is null");
            return (Criteria) this;
        }

        public Criteria andFdutyidIsNotNull() {
            addCriterion("fDutyID is not null");
            return (Criteria) this;
        }

        public Criteria andFdutyidEqualTo(Integer value) {
            addCriterion("fDutyID =", value, "fdutyid");
            return (Criteria) this;
        }

        public Criteria andFdutyidNotEqualTo(Integer value) {
            addCriterion("fDutyID <>", value, "fdutyid");
            return (Criteria) this;
        }

        public Criteria andFdutyidGreaterThan(Integer value) {
            addCriterion("fDutyID >", value, "fdutyid");
            return (Criteria) this;
        }

        public Criteria andFdutyidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fDutyID >=", value, "fdutyid");
            return (Criteria) this;
        }

        public Criteria andFdutyidLessThan(Integer value) {
            addCriterion("fDutyID <", value, "fdutyid");
            return (Criteria) this;
        }

        public Criteria andFdutyidLessThanOrEqualTo(Integer value) {
            addCriterion("fDutyID <=", value, "fdutyid");
            return (Criteria) this;
        }

        public Criteria andFdutyidIn(List<Integer> values) {
            addCriterion("fDutyID in", values, "fdutyid");
            return (Criteria) this;
        }

        public Criteria andFdutyidNotIn(List<Integer> values) {
            addCriterion("fDutyID not in", values, "fdutyid");
            return (Criteria) this;
        }

        public Criteria andFdutyidBetween(Integer value1, Integer value2) {
            addCriterion("fDutyID between", value1, value2, "fdutyid");
            return (Criteria) this;
        }

        public Criteria andFdutyidNotBetween(Integer value1, Integer value2) {
            addCriterion("fDutyID not between", value1, value2, "fdutyid");
            return (Criteria) this;
        }

        public Criteria andFchr1IsNull() {
            addCriterion("fChr1 is null");
            return (Criteria) this;
        }

        public Criteria andFchr1IsNotNull() {
            addCriterion("fChr1 is not null");
            return (Criteria) this;
        }

        public Criteria andFchr1EqualTo(String value) {
            addCriterion("fChr1 =", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotEqualTo(String value) {
            addCriterion("fChr1 <>", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1GreaterThan(String value) {
            addCriterion("fChr1 >", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1GreaterThanOrEqualTo(String value) {
            addCriterion("fChr1 >=", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1LessThan(String value) {
            addCriterion("fChr1 <", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1LessThanOrEqualTo(String value) {
            addCriterion("fChr1 <=", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1Like(String value) {
            addCriterion("fChr1 like", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotLike(String value) {
            addCriterion("fChr1 not like", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1In(List<String> values) {
            addCriterion("fChr1 in", values, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotIn(List<String> values) {
            addCriterion("fChr1 not in", values, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1Between(String value1, String value2) {
            addCriterion("fChr1 between", value1, value2, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotBetween(String value1, String value2) {
            addCriterion("fChr1 not between", value1, value2, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeIsNull() {
            addCriterion("fMonthIncome is null");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeIsNotNull() {
            addCriterion("fMonthIncome is not null");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeEqualTo(BigDecimal value) {
            addCriterion("fMonthIncome =", value, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeNotEqualTo(BigDecimal value) {
            addCriterion("fMonthIncome <>", value, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeGreaterThan(BigDecimal value) {
            addCriterion("fMonthIncome >", value, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fMonthIncome >=", value, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeLessThan(BigDecimal value) {
            addCriterion("fMonthIncome <", value, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fMonthIncome <=", value, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeIn(List<BigDecimal> values) {
            addCriterion("fMonthIncome in", values, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeNotIn(List<BigDecimal> values) {
            addCriterion("fMonthIncome not in", values, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMonthIncome between", value1, value2, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMonthIncome not between", value1, value2, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIsNull() {
            addCriterion("fCompanyID is null");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIsNotNull() {
            addCriterion("fCompanyID is not null");
            return (Criteria) this;
        }

        public Criteria andFcompanyidEqualTo(Integer value) {
            addCriterion("fCompanyID =", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotEqualTo(Integer value) {
            addCriterion("fCompanyID <>", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidGreaterThan(Integer value) {
            addCriterion("fCompanyID >", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCompanyID >=", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidLessThan(Integer value) {
            addCriterion("fCompanyID <", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidLessThanOrEqualTo(Integer value) {
            addCriterion("fCompanyID <=", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIn(List<Integer> values) {
            addCriterion("fCompanyID in", values, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotIn(List<Integer> values) {
            addCriterion("fCompanyID not in", values, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidBetween(Integer value1, Integer value2) {
            addCriterion("fCompanyID between", value1, value2, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotBetween(Integer value1, Integer value2) {
            addCriterion("fCompanyID not between", value1, value2, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFdutyIsNull() {
            addCriterion("fDuty is null");
            return (Criteria) this;
        }

        public Criteria andFdutyIsNotNull() {
            addCriterion("fDuty is not null");
            return (Criteria) this;
        }

        public Criteria andFdutyEqualTo(String value) {
            addCriterion("fDuty =", value, "fduty");
            return (Criteria) this;
        }

        public Criteria andFdutyNotEqualTo(String value) {
            addCriterion("fDuty <>", value, "fduty");
            return (Criteria) this;
        }

        public Criteria andFdutyGreaterThan(String value) {
            addCriterion("fDuty >", value, "fduty");
            return (Criteria) this;
        }

        public Criteria andFdutyGreaterThanOrEqualTo(String value) {
            addCriterion("fDuty >=", value, "fduty");
            return (Criteria) this;
        }

        public Criteria andFdutyLessThan(String value) {
            addCriterion("fDuty <", value, "fduty");
            return (Criteria) this;
        }

        public Criteria andFdutyLessThanOrEqualTo(String value) {
            addCriterion("fDuty <=", value, "fduty");
            return (Criteria) this;
        }

        public Criteria andFdutyLike(String value) {
            addCriterion("fDuty like", value, "fduty");
            return (Criteria) this;
        }

        public Criteria andFdutyNotLike(String value) {
            addCriterion("fDuty not like", value, "fduty");
            return (Criteria) this;
        }

        public Criteria andFdutyIn(List<String> values) {
            addCriterion("fDuty in", values, "fduty");
            return (Criteria) this;
        }

        public Criteria andFdutyNotIn(List<String> values) {
            addCriterion("fDuty not in", values, "fduty");
            return (Criteria) this;
        }

        public Criteria andFdutyBetween(String value1, String value2) {
            addCriterion("fDuty between", value1, value2, "fduty");
            return (Criteria) this;
        }

        public Criteria andFdutyNotBetween(String value1, String value2) {
            addCriterion("fDuty not between", value1, value2, "fduty");
            return (Criteria) this;
        }

        public Criteria andFclientcardidIsNull() {
            addCriterion("fClientCardID is null");
            return (Criteria) this;
        }

        public Criteria andFclientcardidIsNotNull() {
            addCriterion("fClientCardID is not null");
            return (Criteria) this;
        }

        public Criteria andFclientcardidEqualTo(String value) {
            addCriterion("fClientCardID =", value, "fclientcardid");
            return (Criteria) this;
        }

        public Criteria andFclientcardidNotEqualTo(String value) {
            addCriterion("fClientCardID <>", value, "fclientcardid");
            return (Criteria) this;
        }

        public Criteria andFclientcardidGreaterThan(String value) {
            addCriterion("fClientCardID >", value, "fclientcardid");
            return (Criteria) this;
        }

        public Criteria andFclientcardidGreaterThanOrEqualTo(String value) {
            addCriterion("fClientCardID >=", value, "fclientcardid");
            return (Criteria) this;
        }

        public Criteria andFclientcardidLessThan(String value) {
            addCriterion("fClientCardID <", value, "fclientcardid");
            return (Criteria) this;
        }

        public Criteria andFclientcardidLessThanOrEqualTo(String value) {
            addCriterion("fClientCardID <=", value, "fclientcardid");
            return (Criteria) this;
        }

        public Criteria andFclientcardidLike(String value) {
            addCriterion("fClientCardID like", value, "fclientcardid");
            return (Criteria) this;
        }

        public Criteria andFclientcardidNotLike(String value) {
            addCriterion("fClientCardID not like", value, "fclientcardid");
            return (Criteria) this;
        }

        public Criteria andFclientcardidIn(List<String> values) {
            addCriterion("fClientCardID in", values, "fclientcardid");
            return (Criteria) this;
        }

        public Criteria andFclientcardidNotIn(List<String> values) {
            addCriterion("fClientCardID not in", values, "fclientcardid");
            return (Criteria) this;
        }

        public Criteria andFclientcardidBetween(String value1, String value2) {
            addCriterion("fClientCardID between", value1, value2, "fclientcardid");
            return (Criteria) this;
        }

        public Criteria andFclientcardidNotBetween(String value1, String value2) {
            addCriterion("fClientCardID not between", value1, value2, "fclientcardid");
            return (Criteria) this;
        }

        public Criteria andFstr1idIsNull() {
            addCriterion("fStr1ID is null");
            return (Criteria) this;
        }

        public Criteria andFstr1idIsNotNull() {
            addCriterion("fStr1ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstr1idEqualTo(Integer value) {
            addCriterion("fStr1ID =", value, "fstr1id");
            return (Criteria) this;
        }

        public Criteria andFstr1idNotEqualTo(Integer value) {
            addCriterion("fStr1ID <>", value, "fstr1id");
            return (Criteria) this;
        }

        public Criteria andFstr1idGreaterThan(Integer value) {
            addCriterion("fStr1ID >", value, "fstr1id");
            return (Criteria) this;
        }

        public Criteria andFstr1idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStr1ID >=", value, "fstr1id");
            return (Criteria) this;
        }

        public Criteria andFstr1idLessThan(Integer value) {
            addCriterion("fStr1ID <", value, "fstr1id");
            return (Criteria) this;
        }

        public Criteria andFstr1idLessThanOrEqualTo(Integer value) {
            addCriterion("fStr1ID <=", value, "fstr1id");
            return (Criteria) this;
        }

        public Criteria andFstr1idIn(List<Integer> values) {
            addCriterion("fStr1ID in", values, "fstr1id");
            return (Criteria) this;
        }

        public Criteria andFstr1idNotIn(List<Integer> values) {
            addCriterion("fStr1ID not in", values, "fstr1id");
            return (Criteria) this;
        }

        public Criteria andFstr1idBetween(Integer value1, Integer value2) {
            addCriterion("fStr1ID between", value1, value2, "fstr1id");
            return (Criteria) this;
        }

        public Criteria andFstr1idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStr1ID not between", value1, value2, "fstr1id");
            return (Criteria) this;
        }

        public Criteria andFnamePoIsNull() {
            addCriterion("fName_PO is null");
            return (Criteria) this;
        }

        public Criteria andFnamePoIsNotNull() {
            addCriterion("fName_PO is not null");
            return (Criteria) this;
        }

        public Criteria andFnamePoEqualTo(String value) {
            addCriterion("fName_PO =", value, "fnamePo");
            return (Criteria) this;
        }

        public Criteria andFnamePoNotEqualTo(String value) {
            addCriterion("fName_PO <>", value, "fnamePo");
            return (Criteria) this;
        }

        public Criteria andFnamePoGreaterThan(String value) {
            addCriterion("fName_PO >", value, "fnamePo");
            return (Criteria) this;
        }

        public Criteria andFnamePoGreaterThanOrEqualTo(String value) {
            addCriterion("fName_PO >=", value, "fnamePo");
            return (Criteria) this;
        }

        public Criteria andFnamePoLessThan(String value) {
            addCriterion("fName_PO <", value, "fnamePo");
            return (Criteria) this;
        }

        public Criteria andFnamePoLessThanOrEqualTo(String value) {
            addCriterion("fName_PO <=", value, "fnamePo");
            return (Criteria) this;
        }

        public Criteria andFnamePoLike(String value) {
            addCriterion("fName_PO like", value, "fnamePo");
            return (Criteria) this;
        }

        public Criteria andFnamePoNotLike(String value) {
            addCriterion("fName_PO not like", value, "fnamePo");
            return (Criteria) this;
        }

        public Criteria andFnamePoIn(List<String> values) {
            addCriterion("fName_PO in", values, "fnamePo");
            return (Criteria) this;
        }

        public Criteria andFnamePoNotIn(List<String> values) {
            addCriterion("fName_PO not in", values, "fnamePo");
            return (Criteria) this;
        }

        public Criteria andFnamePoBetween(String value1, String value2) {
            addCriterion("fName_PO between", value1, value2, "fnamePo");
            return (Criteria) this;
        }

        public Criteria andFnamePoNotBetween(String value1, String value2) {
            addCriterion("fName_PO not between", value1, value2, "fnamePo");
            return (Criteria) this;
        }

        public Criteria andFcardidPoIsNull() {
            addCriterion("fCardID_PO is null");
            return (Criteria) this;
        }

        public Criteria andFcardidPoIsNotNull() {
            addCriterion("fCardID_PO is not null");
            return (Criteria) this;
        }

        public Criteria andFcardidPoEqualTo(String value) {
            addCriterion("fCardID_PO =", value, "fcardidPo");
            return (Criteria) this;
        }

        public Criteria andFcardidPoNotEqualTo(String value) {
            addCriterion("fCardID_PO <>", value, "fcardidPo");
            return (Criteria) this;
        }

        public Criteria andFcardidPoGreaterThan(String value) {
            addCriterion("fCardID_PO >", value, "fcardidPo");
            return (Criteria) this;
        }

        public Criteria andFcardidPoGreaterThanOrEqualTo(String value) {
            addCriterion("fCardID_PO >=", value, "fcardidPo");
            return (Criteria) this;
        }

        public Criteria andFcardidPoLessThan(String value) {
            addCriterion("fCardID_PO <", value, "fcardidPo");
            return (Criteria) this;
        }

        public Criteria andFcardidPoLessThanOrEqualTo(String value) {
            addCriterion("fCardID_PO <=", value, "fcardidPo");
            return (Criteria) this;
        }

        public Criteria andFcardidPoLike(String value) {
            addCriterion("fCardID_PO like", value, "fcardidPo");
            return (Criteria) this;
        }

        public Criteria andFcardidPoNotLike(String value) {
            addCriterion("fCardID_PO not like", value, "fcardidPo");
            return (Criteria) this;
        }

        public Criteria andFcardidPoIn(List<String> values) {
            addCriterion("fCardID_PO in", values, "fcardidPo");
            return (Criteria) this;
        }

        public Criteria andFcardidPoNotIn(List<String> values) {
            addCriterion("fCardID_PO not in", values, "fcardidPo");
            return (Criteria) this;
        }

        public Criteria andFcardidPoBetween(String value1, String value2) {
            addCriterion("fCardID_PO between", value1, value2, "fcardidPo");
            return (Criteria) this;
        }

        public Criteria andFcardidPoNotBetween(String value1, String value2) {
            addCriterion("fCardID_PO not between", value1, value2, "fcardidPo");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoIsNull() {
            addCriterion("fHandPhone_PO is null");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoIsNotNull() {
            addCriterion("fHandPhone_PO is not null");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoEqualTo(String value) {
            addCriterion("fHandPhone_PO =", value, "fhandphonePo");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoNotEqualTo(String value) {
            addCriterion("fHandPhone_PO <>", value, "fhandphonePo");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoGreaterThan(String value) {
            addCriterion("fHandPhone_PO >", value, "fhandphonePo");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoGreaterThanOrEqualTo(String value) {
            addCriterion("fHandPhone_PO >=", value, "fhandphonePo");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoLessThan(String value) {
            addCriterion("fHandPhone_PO <", value, "fhandphonePo");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoLessThanOrEqualTo(String value) {
            addCriterion("fHandPhone_PO <=", value, "fhandphonePo");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoLike(String value) {
            addCriterion("fHandPhone_PO like", value, "fhandphonePo");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoNotLike(String value) {
            addCriterion("fHandPhone_PO not like", value, "fhandphonePo");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoIn(List<String> values) {
            addCriterion("fHandPhone_PO in", values, "fhandphonePo");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoNotIn(List<String> values) {
            addCriterion("fHandPhone_PO not in", values, "fhandphonePo");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoBetween(String value1, String value2) {
            addCriterion("fHandPhone_PO between", value1, value2, "fhandphonePo");
            return (Criteria) this;
        }

        public Criteria andFhandphonePoNotBetween(String value1, String value2) {
            addCriterion("fHandPhone_PO not between", value1, value2, "fhandphonePo");
            return (Criteria) this;
        }

        public Criteria andFmarryidIsNull() {
            addCriterion("fMarryID is null");
            return (Criteria) this;
        }

        public Criteria andFmarryidIsNotNull() {
            addCriterion("fMarryID is not null");
            return (Criteria) this;
        }

        public Criteria andFmarryidEqualTo(Integer value) {
            addCriterion("fMarryID =", value, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidNotEqualTo(Integer value) {
            addCriterion("fMarryID <>", value, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidGreaterThan(Integer value) {
            addCriterion("fMarryID >", value, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMarryID >=", value, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidLessThan(Integer value) {
            addCriterion("fMarryID <", value, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidLessThanOrEqualTo(Integer value) {
            addCriterion("fMarryID <=", value, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidIn(List<Integer> values) {
            addCriterion("fMarryID in", values, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidNotIn(List<Integer> values) {
            addCriterion("fMarryID not in", values, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidBetween(Integer value1, Integer value2) {
            addCriterion("fMarryID between", value1, value2, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMarryID not between", value1, value2, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIsNull() {
            addCriterion("fCheckDate is null");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIsNotNull() {
            addCriterion("fCheckDate is not null");
            return (Criteria) this;
        }

        public Criteria andFcheckdateEqualTo(Date value) {
            addCriterion("fCheckDate =", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotEqualTo(Date value) {
            addCriterion("fCheckDate <>", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateGreaterThan(Date value) {
            addCriterion("fCheckDate >", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fCheckDate >=", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateLessThan(Date value) {
            addCriterion("fCheckDate <", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateLessThanOrEqualTo(Date value) {
            addCriterion("fCheckDate <=", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIn(List<Date> values) {
            addCriterion("fCheckDate in", values, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotIn(List<Date> values) {
            addCriterion("fCheckDate not in", values, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateBetween(Date value1, Date value2) {
            addCriterion("fCheckDate between", value1, value2, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotBetween(Date value1, Date value2) {
            addCriterion("fCheckDate not between", value1, value2, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFbgaddressIsNull() {
            addCriterion("fBGAddress is null");
            return (Criteria) this;
        }

        public Criteria andFbgaddressIsNotNull() {
            addCriterion("fBGAddress is not null");
            return (Criteria) this;
        }

        public Criteria andFbgaddressEqualTo(String value) {
            addCriterion("fBGAddress =", value, "fbgaddress");
            return (Criteria) this;
        }

        public Criteria andFbgaddressNotEqualTo(String value) {
            addCriterion("fBGAddress <>", value, "fbgaddress");
            return (Criteria) this;
        }

        public Criteria andFbgaddressGreaterThan(String value) {
            addCriterion("fBGAddress >", value, "fbgaddress");
            return (Criteria) this;
        }

        public Criteria andFbgaddressGreaterThanOrEqualTo(String value) {
            addCriterion("fBGAddress >=", value, "fbgaddress");
            return (Criteria) this;
        }

        public Criteria andFbgaddressLessThan(String value) {
            addCriterion("fBGAddress <", value, "fbgaddress");
            return (Criteria) this;
        }

        public Criteria andFbgaddressLessThanOrEqualTo(String value) {
            addCriterion("fBGAddress <=", value, "fbgaddress");
            return (Criteria) this;
        }

        public Criteria andFbgaddressLike(String value) {
            addCriterion("fBGAddress like", value, "fbgaddress");
            return (Criteria) this;
        }

        public Criteria andFbgaddressNotLike(String value) {
            addCriterion("fBGAddress not like", value, "fbgaddress");
            return (Criteria) this;
        }

        public Criteria andFbgaddressIn(List<String> values) {
            addCriterion("fBGAddress in", values, "fbgaddress");
            return (Criteria) this;
        }

        public Criteria andFbgaddressNotIn(List<String> values) {
            addCriterion("fBGAddress not in", values, "fbgaddress");
            return (Criteria) this;
        }

        public Criteria andFbgaddressBetween(String value1, String value2) {
            addCriterion("fBGAddress between", value1, value2, "fbgaddress");
            return (Criteria) this;
        }

        public Criteria andFbgaddressNotBetween(String value1, String value2) {
            addCriterion("fBGAddress not between", value1, value2, "fbgaddress");
            return (Criteria) this;
        }

        public Criteria andFbgspouseIsNull() {
            addCriterion("fBGSpouse is null");
            return (Criteria) this;
        }

        public Criteria andFbgspouseIsNotNull() {
            addCriterion("fBGSpouse is not null");
            return (Criteria) this;
        }

        public Criteria andFbgspouseEqualTo(String value) {
            addCriterion("fBGSpouse =", value, "fbgspouse");
            return (Criteria) this;
        }

        public Criteria andFbgspouseNotEqualTo(String value) {
            addCriterion("fBGSpouse <>", value, "fbgspouse");
            return (Criteria) this;
        }

        public Criteria andFbgspouseGreaterThan(String value) {
            addCriterion("fBGSpouse >", value, "fbgspouse");
            return (Criteria) this;
        }

        public Criteria andFbgspouseGreaterThanOrEqualTo(String value) {
            addCriterion("fBGSpouse >=", value, "fbgspouse");
            return (Criteria) this;
        }

        public Criteria andFbgspouseLessThan(String value) {
            addCriterion("fBGSpouse <", value, "fbgspouse");
            return (Criteria) this;
        }

        public Criteria andFbgspouseLessThanOrEqualTo(String value) {
            addCriterion("fBGSpouse <=", value, "fbgspouse");
            return (Criteria) this;
        }

        public Criteria andFbgspouseLike(String value) {
            addCriterion("fBGSpouse like", value, "fbgspouse");
            return (Criteria) this;
        }

        public Criteria andFbgspouseNotLike(String value) {
            addCriterion("fBGSpouse not like", value, "fbgspouse");
            return (Criteria) this;
        }

        public Criteria andFbgspouseIn(List<String> values) {
            addCriterion("fBGSpouse in", values, "fbgspouse");
            return (Criteria) this;
        }

        public Criteria andFbgspouseNotIn(List<String> values) {
            addCriterion("fBGSpouse not in", values, "fbgspouse");
            return (Criteria) this;
        }

        public Criteria andFbgspouseBetween(String value1, String value2) {
            addCriterion("fBGSpouse between", value1, value2, "fbgspouse");
            return (Criteria) this;
        }

        public Criteria andFbgspouseNotBetween(String value1, String value2) {
            addCriterion("fBGSpouse not between", value1, value2, "fbgspouse");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressIsNull() {
            addCriterion("fSpouseAddress is null");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressIsNotNull() {
            addCriterion("fSpouseAddress is not null");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressEqualTo(String value) {
            addCriterion("fSpouseAddress =", value, "fspouseaddress");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressNotEqualTo(String value) {
            addCriterion("fSpouseAddress <>", value, "fspouseaddress");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressGreaterThan(String value) {
            addCriterion("fSpouseAddress >", value, "fspouseaddress");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressGreaterThanOrEqualTo(String value) {
            addCriterion("fSpouseAddress >=", value, "fspouseaddress");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressLessThan(String value) {
            addCriterion("fSpouseAddress <", value, "fspouseaddress");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressLessThanOrEqualTo(String value) {
            addCriterion("fSpouseAddress <=", value, "fspouseaddress");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressLike(String value) {
            addCriterion("fSpouseAddress like", value, "fspouseaddress");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressNotLike(String value) {
            addCriterion("fSpouseAddress not like", value, "fspouseaddress");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressIn(List<String> values) {
            addCriterion("fSpouseAddress in", values, "fspouseaddress");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressNotIn(List<String> values) {
            addCriterion("fSpouseAddress not in", values, "fspouseaddress");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressBetween(String value1, String value2) {
            addCriterion("fSpouseAddress between", value1, value2, "fspouseaddress");
            return (Criteria) this;
        }

        public Criteria andFspouseaddressNotBetween(String value1, String value2) {
            addCriterion("fSpouseAddress not between", value1, value2, "fspouseaddress");
            return (Criteria) this;
        }

        public Criteria andFspousephoneIsNull() {
            addCriterion("fSpousePhone is null");
            return (Criteria) this;
        }

        public Criteria andFspousephoneIsNotNull() {
            addCriterion("fSpousePhone is not null");
            return (Criteria) this;
        }

        public Criteria andFspousephoneEqualTo(String value) {
            addCriterion("fSpousePhone =", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneNotEqualTo(String value) {
            addCriterion("fSpousePhone <>", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneGreaterThan(String value) {
            addCriterion("fSpousePhone >", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneGreaterThanOrEqualTo(String value) {
            addCriterion("fSpousePhone >=", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneLessThan(String value) {
            addCriterion("fSpousePhone <", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneLessThanOrEqualTo(String value) {
            addCriterion("fSpousePhone <=", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneLike(String value) {
            addCriterion("fSpousePhone like", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneNotLike(String value) {
            addCriterion("fSpousePhone not like", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneIn(List<String> values) {
            addCriterion("fSpousePhone in", values, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneNotIn(List<String> values) {
            addCriterion("fSpousePhone not in", values, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneBetween(String value1, String value2) {
            addCriterion("fSpousePhone between", value1, value2, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneNotBetween(String value1, String value2) {
            addCriterion("fSpousePhone not between", value1, value2, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFdbrIsNull() {
            addCriterion("fDBR is null");
            return (Criteria) this;
        }

        public Criteria andFdbrIsNotNull() {
            addCriterion("fDBR is not null");
            return (Criteria) this;
        }

        public Criteria andFdbrEqualTo(String value) {
            addCriterion("fDBR =", value, "fdbr");
            return (Criteria) this;
        }

        public Criteria andFdbrNotEqualTo(String value) {
            addCriterion("fDBR <>", value, "fdbr");
            return (Criteria) this;
        }

        public Criteria andFdbrGreaterThan(String value) {
            addCriterion("fDBR >", value, "fdbr");
            return (Criteria) this;
        }

        public Criteria andFdbrGreaterThanOrEqualTo(String value) {
            addCriterion("fDBR >=", value, "fdbr");
            return (Criteria) this;
        }

        public Criteria andFdbrLessThan(String value) {
            addCriterion("fDBR <", value, "fdbr");
            return (Criteria) this;
        }

        public Criteria andFdbrLessThanOrEqualTo(String value) {
            addCriterion("fDBR <=", value, "fdbr");
            return (Criteria) this;
        }

        public Criteria andFdbrLike(String value) {
            addCriterion("fDBR like", value, "fdbr");
            return (Criteria) this;
        }

        public Criteria andFdbrNotLike(String value) {
            addCriterion("fDBR not like", value, "fdbr");
            return (Criteria) this;
        }

        public Criteria andFdbrIn(List<String> values) {
            addCriterion("fDBR in", values, "fdbr");
            return (Criteria) this;
        }

        public Criteria andFdbrNotIn(List<String> values) {
            addCriterion("fDBR not in", values, "fdbr");
            return (Criteria) this;
        }

        public Criteria andFdbrBetween(String value1, String value2) {
            addCriterion("fDBR between", value1, value2, "fdbr");
            return (Criteria) this;
        }

        public Criteria andFdbrNotBetween(String value1, String value2) {
            addCriterion("fDBR not between", value1, value2, "fdbr");
            return (Criteria) this;
        }

        public Criteria andFdbraddressIsNull() {
            addCriterion("fDBRAddress is null");
            return (Criteria) this;
        }

        public Criteria andFdbraddressIsNotNull() {
            addCriterion("fDBRAddress is not null");
            return (Criteria) this;
        }

        public Criteria andFdbraddressEqualTo(String value) {
            addCriterion("fDBRAddress =", value, "fdbraddress");
            return (Criteria) this;
        }

        public Criteria andFdbraddressNotEqualTo(String value) {
            addCriterion("fDBRAddress <>", value, "fdbraddress");
            return (Criteria) this;
        }

        public Criteria andFdbraddressGreaterThan(String value) {
            addCriterion("fDBRAddress >", value, "fdbraddress");
            return (Criteria) this;
        }

        public Criteria andFdbraddressGreaterThanOrEqualTo(String value) {
            addCriterion("fDBRAddress >=", value, "fdbraddress");
            return (Criteria) this;
        }

        public Criteria andFdbraddressLessThan(String value) {
            addCriterion("fDBRAddress <", value, "fdbraddress");
            return (Criteria) this;
        }

        public Criteria andFdbraddressLessThanOrEqualTo(String value) {
            addCriterion("fDBRAddress <=", value, "fdbraddress");
            return (Criteria) this;
        }

        public Criteria andFdbraddressLike(String value) {
            addCriterion("fDBRAddress like", value, "fdbraddress");
            return (Criteria) this;
        }

        public Criteria andFdbraddressNotLike(String value) {
            addCriterion("fDBRAddress not like", value, "fdbraddress");
            return (Criteria) this;
        }

        public Criteria andFdbraddressIn(List<String> values) {
            addCriterion("fDBRAddress in", values, "fdbraddress");
            return (Criteria) this;
        }

        public Criteria andFdbraddressNotIn(List<String> values) {
            addCriterion("fDBRAddress not in", values, "fdbraddress");
            return (Criteria) this;
        }

        public Criteria andFdbraddressBetween(String value1, String value2) {
            addCriterion("fDBRAddress between", value1, value2, "fdbraddress");
            return (Criteria) this;
        }

        public Criteria andFdbraddressNotBetween(String value1, String value2) {
            addCriterion("fDBRAddress not between", value1, value2, "fdbraddress");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneIsNull() {
            addCriterion("fDBRPhone is null");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneIsNotNull() {
            addCriterion("fDBRPhone is not null");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneEqualTo(String value) {
            addCriterion("fDBRPhone =", value, "fdbrphone");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneNotEqualTo(String value) {
            addCriterion("fDBRPhone <>", value, "fdbrphone");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneGreaterThan(String value) {
            addCriterion("fDBRPhone >", value, "fdbrphone");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneGreaterThanOrEqualTo(String value) {
            addCriterion("fDBRPhone >=", value, "fdbrphone");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneLessThan(String value) {
            addCriterion("fDBRPhone <", value, "fdbrphone");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneLessThanOrEqualTo(String value) {
            addCriterion("fDBRPhone <=", value, "fdbrphone");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneLike(String value) {
            addCriterion("fDBRPhone like", value, "fdbrphone");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneNotLike(String value) {
            addCriterion("fDBRPhone not like", value, "fdbrphone");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneIn(List<String> values) {
            addCriterion("fDBRPhone in", values, "fdbrphone");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneNotIn(List<String> values) {
            addCriterion("fDBRPhone not in", values, "fdbrphone");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneBetween(String value1, String value2) {
            addCriterion("fDBRPhone between", value1, value2, "fdbrphone");
            return (Criteria) this;
        }

        public Criteria andFdbrphoneNotBetween(String value1, String value2) {
            addCriterion("fDBRPhone not between", value1, value2, "fdbrphone");
            return (Criteria) this;
        }

        public Criteria andFarchivesidIsNull() {
            addCriterion("fArchivesID is null");
            return (Criteria) this;
        }

        public Criteria andFarchivesidIsNotNull() {
            addCriterion("fArchivesID is not null");
            return (Criteria) this;
        }

        public Criteria andFarchivesidEqualTo(Integer value) {
            addCriterion("fArchivesID =", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidNotEqualTo(Integer value) {
            addCriterion("fArchivesID <>", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidGreaterThan(Integer value) {
            addCriterion("fArchivesID >", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fArchivesID >=", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidLessThan(Integer value) {
            addCriterion("fArchivesID <", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidLessThanOrEqualTo(Integer value) {
            addCriterion("fArchivesID <=", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidIn(List<Integer> values) {
            addCriterion("fArchivesID in", values, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidNotIn(List<Integer> values) {
            addCriterion("fArchivesID not in", values, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidBetween(Integer value1, Integer value2) {
            addCriterion("fArchivesID between", value1, value2, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidNotBetween(Integer value1, Integer value2) {
            addCriterion("fArchivesID not between", value1, value2, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIsNull() {
            addCriterion("fRunStatusID is null");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIsNotNull() {
            addCriterion("fRunStatusID is not null");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidEqualTo(Integer value) {
            addCriterion("fRunStatusID =", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotEqualTo(Integer value) {
            addCriterion("fRunStatusID <>", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidGreaterThan(Integer value) {
            addCriterion("fRunStatusID >", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fRunStatusID >=", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidLessThan(Integer value) {
            addCriterion("fRunStatusID <", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidLessThanOrEqualTo(Integer value) {
            addCriterion("fRunStatusID <=", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIn(List<Integer> values) {
            addCriterion("fRunStatusID in", values, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotIn(List<Integer> values) {
            addCriterion("fRunStatusID not in", values, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidBetween(Integer value1, Integer value2) {
            addCriterion("fRunStatusID between", value1, value2, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotBetween(Integer value1, Integer value2) {
            addCriterion("fRunStatusID not between", value1, value2, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidIsNull() {
            addCriterion("fSCompanyID is null");
            return (Criteria) this;
        }

        public Criteria andFscompanyidIsNotNull() {
            addCriterion("fSCompanyID is not null");
            return (Criteria) this;
        }

        public Criteria andFscompanyidEqualTo(Integer value) {
            addCriterion("fSCompanyID =", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidNotEqualTo(Integer value) {
            addCriterion("fSCompanyID <>", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidGreaterThan(Integer value) {
            addCriterion("fSCompanyID >", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fSCompanyID >=", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidLessThan(Integer value) {
            addCriterion("fSCompanyID <", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidLessThanOrEqualTo(Integer value) {
            addCriterion("fSCompanyID <=", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidIn(List<Integer> values) {
            addCriterion("fSCompanyID in", values, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidNotIn(List<Integer> values) {
            addCriterion("fSCompanyID not in", values, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidBetween(Integer value1, Integer value2) {
            addCriterion("fSCompanyID between", value1, value2, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidNotBetween(Integer value1, Integer value2) {
            addCriterion("fSCompanyID not between", value1, value2, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFdownidIsNull() {
            addCriterion("fDownID is null");
            return (Criteria) this;
        }

        public Criteria andFdownidIsNotNull() {
            addCriterion("fDownID is not null");
            return (Criteria) this;
        }

        public Criteria andFdownidEqualTo(Integer value) {
            addCriterion("fDownID =", value, "fdownid");
            return (Criteria) this;
        }

        public Criteria andFdownidNotEqualTo(Integer value) {
            addCriterion("fDownID <>", value, "fdownid");
            return (Criteria) this;
        }

        public Criteria andFdownidGreaterThan(Integer value) {
            addCriterion("fDownID >", value, "fdownid");
            return (Criteria) this;
        }

        public Criteria andFdownidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fDownID >=", value, "fdownid");
            return (Criteria) this;
        }

        public Criteria andFdownidLessThan(Integer value) {
            addCriterion("fDownID <", value, "fdownid");
            return (Criteria) this;
        }

        public Criteria andFdownidLessThanOrEqualTo(Integer value) {
            addCriterion("fDownID <=", value, "fdownid");
            return (Criteria) this;
        }

        public Criteria andFdownidIn(List<Integer> values) {
            addCriterion("fDownID in", values, "fdownid");
            return (Criteria) this;
        }

        public Criteria andFdownidNotIn(List<Integer> values) {
            addCriterion("fDownID not in", values, "fdownid");
            return (Criteria) this;
        }

        public Criteria andFdownidBetween(Integer value1, Integer value2) {
            addCriterion("fDownID between", value1, value2, "fdownid");
            return (Criteria) this;
        }

        public Criteria andFdownidNotBetween(Integer value1, Integer value2) {
            addCriterion("fDownID not between", value1, value2, "fdownid");
            return (Criteria) this;
        }

        public Criteria andFexecuteeIsNull() {
            addCriterion("fExecutee is null");
            return (Criteria) this;
        }

        public Criteria andFexecuteeIsNotNull() {
            addCriterion("fExecutee is not null");
            return (Criteria) this;
        }

        public Criteria andFexecuteeEqualTo(Integer value) {
            addCriterion("fExecutee =", value, "fexecutee");
            return (Criteria) this;
        }

        public Criteria andFexecuteeNotEqualTo(Integer value) {
            addCriterion("fExecutee <>", value, "fexecutee");
            return (Criteria) this;
        }

        public Criteria andFexecuteeGreaterThan(Integer value) {
            addCriterion("fExecutee >", value, "fexecutee");
            return (Criteria) this;
        }

        public Criteria andFexecuteeGreaterThanOrEqualTo(Integer value) {
            addCriterion("fExecutee >=", value, "fexecutee");
            return (Criteria) this;
        }

        public Criteria andFexecuteeLessThan(Integer value) {
            addCriterion("fExecutee <", value, "fexecutee");
            return (Criteria) this;
        }

        public Criteria andFexecuteeLessThanOrEqualTo(Integer value) {
            addCriterion("fExecutee <=", value, "fexecutee");
            return (Criteria) this;
        }

        public Criteria andFexecuteeIn(List<Integer> values) {
            addCriterion("fExecutee in", values, "fexecutee");
            return (Criteria) this;
        }

        public Criteria andFexecuteeNotIn(List<Integer> values) {
            addCriterion("fExecutee not in", values, "fexecutee");
            return (Criteria) this;
        }

        public Criteria andFexecuteeBetween(Integer value1, Integer value2) {
            addCriterion("fExecutee between", value1, value2, "fexecutee");
            return (Criteria) this;
        }

        public Criteria andFexecuteeNotBetween(Integer value1, Integer value2) {
            addCriterion("fExecutee not between", value1, value2, "fexecutee");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneIsNull() {
            addCriterion("fExecuteePhone is null");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneIsNotNull() {
            addCriterion("fExecuteePhone is not null");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneEqualTo(String value) {
            addCriterion("fExecuteePhone =", value, "fexecuteephone");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneNotEqualTo(String value) {
            addCriterion("fExecuteePhone <>", value, "fexecuteephone");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneGreaterThan(String value) {
            addCriterion("fExecuteePhone >", value, "fexecuteephone");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneGreaterThanOrEqualTo(String value) {
            addCriterion("fExecuteePhone >=", value, "fexecuteephone");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneLessThan(String value) {
            addCriterion("fExecuteePhone <", value, "fexecuteephone");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneLessThanOrEqualTo(String value) {
            addCriterion("fExecuteePhone <=", value, "fexecuteephone");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneLike(String value) {
            addCriterion("fExecuteePhone like", value, "fexecuteephone");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneNotLike(String value) {
            addCriterion("fExecuteePhone not like", value, "fexecuteephone");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneIn(List<String> values) {
            addCriterion("fExecuteePhone in", values, "fexecuteephone");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneNotIn(List<String> values) {
            addCriterion("fExecuteePhone not in", values, "fexecuteephone");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneBetween(String value1, String value2) {
            addCriterion("fExecuteePhone between", value1, value2, "fexecuteephone");
            return (Criteria) this;
        }

        public Criteria andFexecuteephoneNotBetween(String value1, String value2) {
            addCriterion("fExecuteePhone not between", value1, value2, "fexecuteephone");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressIsNull() {
            addCriterion("fExecuteeAddress is null");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressIsNotNull() {
            addCriterion("fExecuteeAddress is not null");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressEqualTo(String value) {
            addCriterion("fExecuteeAddress =", value, "fexecuteeaddress");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressNotEqualTo(String value) {
            addCriterion("fExecuteeAddress <>", value, "fexecuteeaddress");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressGreaterThan(String value) {
            addCriterion("fExecuteeAddress >", value, "fexecuteeaddress");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressGreaterThanOrEqualTo(String value) {
            addCriterion("fExecuteeAddress >=", value, "fexecuteeaddress");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressLessThan(String value) {
            addCriterion("fExecuteeAddress <", value, "fexecuteeaddress");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressLessThanOrEqualTo(String value) {
            addCriterion("fExecuteeAddress <=", value, "fexecuteeaddress");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressLike(String value) {
            addCriterion("fExecuteeAddress like", value, "fexecuteeaddress");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressNotLike(String value) {
            addCriterion("fExecuteeAddress not like", value, "fexecuteeaddress");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressIn(List<String> values) {
            addCriterion("fExecuteeAddress in", values, "fexecuteeaddress");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressNotIn(List<String> values) {
            addCriterion("fExecuteeAddress not in", values, "fexecuteeaddress");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressBetween(String value1, String value2) {
            addCriterion("fExecuteeAddress between", value1, value2, "fexecuteeaddress");
            return (Criteria) this;
        }

        public Criteria andFexecuteeaddressNotBetween(String value1, String value2) {
            addCriterion("fExecuteeAddress not between", value1, value2, "fexecuteeaddress");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}